UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nVSI8JzXZG2qvGjfjlJerfE1HRKA901VPRAP1LESVHo='
WHERE
key_id = '96fb775d3fca40792e0fb1acdc1a6ae001b94969fbd06bf7bef018c3d2518ff0'
AND (
token = 'nVSI8JzXZG2qvGjfjlJerfE1HRKA901VPRAP1LESVHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)