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