UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZtW9ZQmP+sKoHDIiTUXnkWtxZqO2fKzgIiecS1/G78s='
WHERE
key_id = '0d4146384644a2f792b9a1f8c3416fe31d871ea6f51c353e1ba843d211c818fc'
AND (
token = 'ZtW9ZQmP+sKoHDIiTUXnkWtxZqO2fKzgIiecS1/G78s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)