UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r26tticE3MV6M8bfjcdROQHN93bZby07i3UGjeLgzCk='
WHERE
key_id = '8bbc3ce871a7e1dc8c9f42f1c88ef46ab7e81fc1add6a55306e639bb36c0eea8'
AND (
token = 'r26tticE3MV6M8bfjcdROQHN93bZby07i3UGjeLgzCk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)