UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Wd3amcl1A+xSB27IxJS0U7Os0hH0W9CC5e+jk066F2M='
WHERE
key_id = 'e27000afbf964082aa29f7235521d71da8dec63479ff18cfd304e2e10fc757f6'
AND (
token = 'Wd3amcl1A+xSB27IxJS0U7Os0hH0W9CC5e+jk066F2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)