UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'otPwI63Df0x4OGY5C8xNyydY/oYj+zSqzExxQV24xM0='
WHERE
key_id = '7736ed7a0ac145db4fc45b21b803e8e7bfafd2c08911e8e8065f7a9a87d102c0'
AND (
token = 'otPwI63Df0x4OGY5C8xNyydY/oYj+zSqzExxQV24xM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)