UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8voI/fX+1wNRt2vfG9BNzTZYq4EVpJooiOBoGPCAe8='
WHERE
key_id = '23ad0e9cab8318871a3f46fa64a069424dd5c3b7fd48ca9d4e6b149369e6b3cd'
AND (
token = 'N8voI/fX+1wNRt2vfG9BNzTZYq4EVpJooiOBoGPCAe8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)