UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '25tGi1dpY9k6r2c4ijygX8LOj8dOZzJsZC1At9HPvgg='
WHERE
key_id = '349cb704946b73ce663efea2a47a522b5faf02a0c6feaff9e7557619e2ef4408'
AND (
token = '25tGi1dpY9k6r2c4ijygX8LOj8dOZzJsZC1At9HPvgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)