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