UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xo2+Ulg1B/rEucpt+skTEMzMTfxyKHjJPPQlin35XK8='
WHERE
key_id = 'a676047239d9b8992cc9ea1fd47ae83a1ff3272bbe33a5e896babfa53c802867'
AND (
token = 'Xo2+Ulg1B/rEucpt+skTEMzMTfxyKHjJPPQlin35XK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)