UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6rsHTb+a+oQx/2BNV5sW3ZEk7JqaZqGpHal4RXBWhsE='
WHERE
key_id = 'e8aff90cae8444f9507e34bfb2c2609123581b65af1828e6c45243a207831914'
AND (
token = '6rsHTb+a+oQx/2BNV5sW3ZEk7JqaZqGpHal4RXBWhsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)