UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XfbnI6LcvZrjNKN17nFPhsl05H4Lk1Jc5/p3bKZk7To='
WHERE
key_id = '0ed220209fa7813f7ef73a02cbaa309ceb93f2f87b08dc84b91b269ecb827301'
AND (
token = 'XfbnI6LcvZrjNKN17nFPhsl05H4Lk1Jc5/p3bKZk7To='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)