UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YCgUznBF+K1LBYhQAxfHMaf/eKMXnuyivOM66qBBOnE='
WHERE
key_id = '4d31efca07f659316f46e407642f61a69be39b252331d9207e516ecbad41de12'
AND (
token = 'YCgUznBF+K1LBYhQAxfHMaf/eKMXnuyivOM66qBBOnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)