UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1S1dBfeenOHVWVD3WioEtUouLavbe7+2rd7P22eLSzw='
WHERE
key_id = '195e0e89083d4bcbab2e86785799eeaf82440ad5cbb1fb993b1e2da6c586fcce'
AND (
token = '1S1dBfeenOHVWVD3WioEtUouLavbe7+2rd7P22eLSzw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)