UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gmSIjsFhEg6N+LvMjgRBf4GgxWWlBvWwzkX9SgtnoA='
WHERE
key_id = '304c646c71e26c73b9e2098a441314af75c786a8c66a08cf6a2f6c439e3d68df'
AND (
token = '6gmSIjsFhEg6N+LvMjgRBf4GgxWWlBvWwzkX9SgtnoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)