UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nb4HxqS9BqLUILSeHbzb9Nz36y+e9OyfnAXFZUmqpUc='
WHERE
key_id = '21ec1db2fb6a548e065223481c2b9d46d227706231c29868b891ee2bcef048cb'
AND (
token = 'nb4HxqS9BqLUILSeHbzb9Nz36y+e9OyfnAXFZUmqpUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)