UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1PIwgzraktHIaLxpVjVJchlmElji/g62Q+X/a7PfCJ4='
WHERE
key_id = '6919a711305aca681a469a629028579b29045b2e35ce26d608ebde87464f3f4a'
AND (
token = '1PIwgzraktHIaLxpVjVJchlmElji/g62Q+X/a7PfCJ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)