UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i+u8CIgqxp6CffLQuM5dMFhJBgmih3tSULHNNo90xpI='
WHERE
key_id = '3455d4df6dae34eddd67d72e2e0de57c8fc4454ba925ae43905b323663841eb2'
AND (
token = 'i+u8CIgqxp6CffLQuM5dMFhJBgmih3tSULHNNo90xpI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)