UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jw/Y3A/8TSrZuDqm1Nyda9Er7W/4hHaa63wObFjrizg='
WHERE
key_id = 'a7f07eac2054663949c05c9d3780916b21d1b80eb914b766f3358a6bc9bd243d'
AND (
token = 'Jw/Y3A/8TSrZuDqm1Nyda9Er7W/4hHaa63wObFjrizg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)