UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eaFyCubXjwvslwUqF76RTG+YJfVUEYHGd/mf7rAccw8='
WHERE
key_id = '9efb6ee1d2d4ba4c5c433c2f2584cf4eb53880a84cf36b0f300a6b5d219640de'
AND (
token = 'eaFyCubXjwvslwUqF76RTG+YJfVUEYHGd/mf7rAccw8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)