UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5VXsZsN6naAif6qeM7NKz6GLb1YcrK1bppjoAAowZxg='
WHERE
key_id = 'c304c5d7a4f13706ad5d24d0758695b969fed5fc5de024994a6ab21ddcad2188'
AND (
token = '5VXsZsN6naAif6qeM7NKz6GLb1YcrK1bppjoAAowZxg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)