UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jv/ieE26qez5PWBg22tGyk+d0gCpNTr0zqKqTHJouHU='
WHERE
key_id = 'e99ea32e3a4219270ef322ceda681507b694ca10c795c776d4d6630931b78b1f'
AND (
token = 'jv/ieE26qez5PWBg22tGyk+d0gCpNTr0zqKqTHJouHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)