UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8hZ7AbkqYOi5+o4XnlG4K0C0MqeMbHu4LyhWF0OPgpo='
WHERE
key_id = '0d4c305404201599a6f75618249846d0ecb938df20dcebc6dcc9db70217a157f'
AND (
token = '8hZ7AbkqYOi5+o4XnlG4K0C0MqeMbHu4LyhWF0OPgpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)