UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SKhJan5JBaluQHuc+ZdI1I9GJwZbfALV/viQNif9V7A='
WHERE
key_id = '1b2729a737f47d0738fb1e914ecf8ff85034540fba75c748942ce88f3474ff3e'
AND (
token = 'SKhJan5JBaluQHuc+ZdI1I9GJwZbfALV/viQNif9V7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)