UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BP19ZnULBySfHHagFAJakc9O0GuFPbPF5uxxgHiRBZg='
WHERE
key_id = 'fedd8042c96cdd6068d308e81e7c1776491ea0a92f9defb15dd7a3e6b2b1d82b'
AND (
token = 'BP19ZnULBySfHHagFAJakc9O0GuFPbPF5uxxgHiRBZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)