UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ptdkkK6AxsLVZUicOH6PTJYPSvbzxLBMjXGVmJqk8/8='
WHERE
key_id = 'bc4e4a2027f3fdce64726705f40bd26b8120a2d8529ce7557bd95b28ac30d87d'
AND (
token = 'ptdkkK6AxsLVZUicOH6PTJYPSvbzxLBMjXGVmJqk8/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)