UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Q0ihCWiKdvDTo4no2lPoLYOXD2N10b1Q2KxYz/ptn0='
WHERE
key_id = '645bf0e872040712b7a5863ac436391b7376b35d97847eabfa621127e23f2937'
AND (
token = '1Q0ihCWiKdvDTo4no2lPoLYOXD2N10b1Q2KxYz/ptn0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)