UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pyBPuJW7P6/wSqE4Z6ZB56u5w/cyTea5TpK4jTTG6jA='
WHERE
key_id = 'b20659c2937d1851b5799af5052c58d66a0fcefd4be271e7b1ffaa6e0a1ec345'
AND (
token = 'pyBPuJW7P6/wSqE4Z6ZB56u5w/cyTea5TpK4jTTG6jA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)