UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BKnB64fiX04w10JB63tH5UOiHVTkbYYEX4q8SWIBfhk='
WHERE
key_id = '4fcef215993e84131eb0e91448a38a774a770b2271fe1acbe40c0e2b5a09266d'
AND (
token = 'BKnB64fiX04w10JB63tH5UOiHVTkbYYEX4q8SWIBfhk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)