UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A7vVv1QO8217/vwqCbEBB5+0sG3LH77yIfPSYDEmEAI='
WHERE
key_id = 'e7b5a46572f3f95dd97f6372dd7145ab7d32307f0e8c48208e8e3f97674db937'
AND (
token = 'A7vVv1QO8217/vwqCbEBB5+0sG3LH77yIfPSYDEmEAI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)