UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8WiIe6zprw0UwipxkdOjyaG4Q0Pk/kpI+1Srafky/i4='
WHERE
key_id = '87b89532c50dddd2ed697621d56a4bdfc657b7ba7e3b9ef37f31a1bfd304073b'
AND (
token = '8WiIe6zprw0UwipxkdOjyaG4Q0Pk/kpI+1Srafky/i4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)