UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YlzYpOv5be/kxtqwYWuDsFuFw/AbPdyJ+vLnIS067v8='
WHERE
key_id = 'b1ac9b53caa59020005593fa44cd13b2cbd0a4b34a12b291078b0a58f26994e5'
AND (
token = 'YlzYpOv5be/kxtqwYWuDsFuFw/AbPdyJ+vLnIS067v8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)