UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rU1TpJlv2UGcwOnVkzhFl/T98pGHUbftKc1KSmPRN70='
WHERE
key_id = 'a7521329ee30e0ee33ba1019773f297b45a969aca23467ff1e0ad1a2da54a54c'
AND (
token = 'rU1TpJlv2UGcwOnVkzhFl/T98pGHUbftKc1KSmPRN70='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)