UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZVkFHT9+RBLlUN93Moc45jAgs9k/kDDn4fHX9C1MDzA='
WHERE
key_id = 'e8b3f12f6b009b9116aabe0030449f58ce00443079bc550912344f9b9483cddd'
AND (
token = 'ZVkFHT9+RBLlUN93Moc45jAgs9k/kDDn4fHX9C1MDzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)