UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZKUVLwvY6D5WtkgA9/v5M/h42EJKmn++dAEXVcsfG8g='
WHERE
key_id = '48a2e0f139988d843107699fb951b510945659c0cac15d676d654e880a1fd496'
AND (
token = 'ZKUVLwvY6D5WtkgA9/v5M/h42EJKmn++dAEXVcsfG8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)